package com.whats.indicator.gensql;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.InputStreamReader;

public class GenSql {

    public static void main(String[] args) throws Exception {
//        BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream("aaa.txt")));
//        String content;
//        while ((content = br.readLine()) != null) {
//            String []str = content.split("，");
//            String sql = "insert into t_zbkb_parameter_config_f(param_name,param_code,parent_id,param_type) values('" + str[1].trim() +"','" + str[0].trim() + "',183,'equip_type');";
//            System.out.println(sql);
//        }

        BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream("bbb.txt")));
        String content;
        while ((content = br.readLine()) != null) {
            String []str = content.split("，");
            String sql = "insert into t_zbkb_parameter_config_f(param_name,param_code,parent_id,param_type) values('" + str[1].trim() +"','" + str[0].trim() + "',184,'equip_type');";
            System.out.println(sql);
        }
    }
}
